<%@page import="com.dts.project.dao.ElectricityBillMasterDao"%>
<%@page import="com.dts.core.util.CoreList"%>
<%@page import="java.util.Enumeration"%>
<%@page import="com.yourcompany.struts.form.ElectricityBillMasterForm"%>


<!DOCTYPE HTML PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/transitional.dtd">
<html>
<head>
<style>
body,td,th {
	color: #B00606;
	font-family: Verdana, Arial, Helvetica, sans-serif;
}
body {
	background-color: #003333;
}
.style1 {
	color: #B00606;
	font-weight: bold;
}
</style>

<title>My Village</title>
<script type="text/javascript" src="scripts/moveclock.js"></script>


<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /></head>
<body>
<table width="750" align="center" bgcolor="#B00606">
<tr><td>
<img src="images/epostoffice.gif" width="780"></td>
</tr>
<tr>
   <td bgcolor="#E16A00">
   <jsp:include page="UserOptions.jsp"/>
   </td></tr>
<tr><td>
<%--<div align="center">--%>
<%--<table bgcolor="#B00606" width="750" align="center">--%>
<%--<tr>--%>
<%--   <td><jsp:include page="Template.html"/></td></tr></table></div>--%>
<div align="center">
<table bgcolor="#B00606" width="770" align="center" height="70">
<tr>
   <td>
   
   <marquee><font color="#ECEDF3"><h1>WELCOME TO THE USER</h1></marquee>
<marquee> <img src="images/IndianStamps.gif" height="100"><img src="images/ist2_1276217-vintage-indian-stamps-ephemera.jpg" height="100"><img src="images/images.jpeg" height="100"><img src="images/images1.jpeg" height="100"><img src="images/stamp price.jpg" height="100"><img src="images/2007-03-28-sw-stamps.jpg" height="100"><img src="images/6a00d83452795369e200e5506182958834-500wi.jpg" height="100"><img src="images/stamp-avocet.JPG" height="100"></marquee>
   <p align="center">
   
    <p>&nbsp;</p><font color="white"><b>  Export to :</b> <a href="ExportXLS" target="_blank"><font color="white"><b>XLS</b></a>
     <div align="center"><font color="white"><b>
       <%if(request.getParameter("status")!=null){ %>
              <%=request.getParameter("status") %>
       <%} %>
             <%
try
{
String report="";
report+=" <table align=center border=1>           <tr bgcolor=#509C16>    <td><div align=center><font color=white><b>BillDate</b></font></div></td>                    <td><div align=center><font color=white><b>BillNo</b></font></div></td>             <td><div align=center><font color=white><b>ServiceNo</b></font></div></td>          <td><div align=center><font color=white><b>NoOfUnits</b></font></div></td>          <td><div align=center><font color=white><b>Amount</b></font></div></td>             </tr>";
//ElectricityBillMasterDao dao=new ElectricityBillMasterDao();
CoreList cl=(CoreList)request.getAttribute("viewElectrictyBills");
Enumeration en=cl.elements();
%>
       </b></font>
       <h2><font color="white">View Electricity Bills</font></h2>
         <table align="center" border=1>
           <tr bgcolor="#509C16">
    <td><div align="center"><font color="white"><b>BillDate</b></font></div></td>       
             
<td><div align="center"><font color="white"><b>BillNo</b></font></div></td>         
    <td><div align="center"><font color="white"><b>ServiceNo</b></font></div></td>      
    <td><div align="center"><font color="white"><b>NoOfUnits</b></font></div></td>      
    <td><div align="center"><font color="white"><b>Amount</b></font></div></td>         
    </tr>
           <%while(en.hasMoreElements()) 
{
ElectricityBillMasterForm form=(ElectricityBillMasterForm)en.nextElement();
report+=" <tr bgcolor=#C3D7BA>    <td><span class=style1>"+form.getBillDate() +"</span></td>    <td align=center><span class=style1>"+form.getBillNo() +"</span></td>    <td align=center><span class=style1>"+form.getServiceNo() +"</span></td>    <td align=center><span class=style1>"+form.getNoOfUnits() +"</span></td>    <td align=center><span class=style1>"+form.getAmount() +"</span></td>    </tr>";
%>
           <tr bgcolor="#C3D7BA">
    <td><span class="style1"><%=form.getBillDate() %></span></td>
    <td align=center><span class="style1"><%=form.getBillNo() %></span></td>
    <td align=center><span class="style1"><%=form.getServiceNo() %></span></td>
    <td align=center><span class="style1"><%=form.getNoOfUnits() %></span></td>
    <td align=center><span class="style1"><%=form.getAmount() %></span></td>
    </tr>
           <%} report+="</table>";
             session.setAttribute("Report",report);}catch(Exception e)
{
e.printStackTrace();
}
%>       
         </table>
     </div></td></tr></table>
          <p>&nbsp;</p>
               <p>&nbsp;</p>
                    <p>&nbsp;</p>
                         
           <p>&nbsp;</p>
               <p>&nbsp;</p>
                    <p>&nbsp;</p>
                         
           <p>&nbsp;</p>
             
                         
                              
     <p>&nbsp;</p></div>


</body></html>